package app.softtech.freechat.database;

public class ConstantsDB {
	// All Static variables
    // Database Version
	public static final int DATABASE_VERSION = 1;
	
	// Database name
	public  static final String DATABASE_NAME = "database_freechat_client";
	
	// Table name
	public static final String DATABASE_USER = "DatabaseUser";
	public static final String DATABASE_FRIEND = "DatabaseFriend";
	public static final String DATABASE_CHAT = "DatabaseChat";
	public static final String DATABASE_GROUP = "DatabaseGruop";
	public static final String DATABASE_MEMBER_IN_GROUP = "DatabaseMemberInGroup";
	
	// Common Columns name
	public static final String ID = "id";
	public static final String USER_ID = "user_id";
	public static final String GROUP_ID ="group_id";
	
	// DatabaseUser table - columns name
	public static final String USERNAME = "username";
	public static final String PASSWORD = "password";
	public static final String EMAIL = "email";
	public static final String PHONE = "phone";
	public static final String AVATAR = "avatar";
	public static final String IS_LOGGEDIN = "is_loggedin";
	public static final String STATUS = "status";
	
	// DatabaseFriend table - columns name
	public static final String FRIEND_ID = "friend_id";
	public static final String FRIEND_NAME = "friend_name";
	public static final String FRIEND_AVATAR = "friend_avatar";
	public static final String FRIEND_STATUS = "friend_status";
	public static final String FRIEND_PHONE = "friend_phone";
	public static final String LAST_MESSAGE = "last_message";	
	public static final String REQUEST_ID = "request_id";
	
	// DatabaseGroup table - columns name
	public static final String GROUP_NAME = "groupname";
	
	// DatabaseMemberInGroup- columns name
	public static final String USER_ID_IN_SERVER = "user_id_in_server";
	public static final String IS_IN_FRIEND_LIST = "is_in_friend_list";
	public static final String USER_NAME_IN_SERVER = "user_name_in_server";
	
	// DatabaseChat
	public static final String MESSAGE = "message";
	public static final String ISSEND = "isSend";
	public static final String DATECHAT = "dateChat";

}
